EMT Practice Test

1. Question Content...

---

Question1: Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

Question2: An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

Question3: Which DB2 product/feature should be used if you want to enable client reroute for transactions and connections based on workload?

Question4: Which table space is NOT created by default when the CREATE DATABASE command is executed?

Question5: You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

Question6: What are two types of DB2 Discovery requests that a client can make? (Choose two.)

Question7: Which is a valid statement about the Row and Column Access Control (RCAC) feature?

Question8: Which statement describes adaptive row compression?

Question9: If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

Question10: Which tool should be used to give you lock wait information from the DB2 memory sets?

Question11: Which statement is true regarding client-server database connectivity?

Question12: Which statement is true about Insert Time Clustering (ITC) tables?

Question13: Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?

Question14: What is the MAX_LOG database configuration parameter used for?

Question15: Which statement is correct when describing trusted contexts?

Question16: If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?

Question17: Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

Question18: Given the following statement:

How many constraints are present in the DEPARTMENT table?

Question19: Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?

Question20: Which tool should be used to collect data during a potential hang without stopping the database manager?

Question21: If the following statement is executed:

What indexes will be created for table TAB1?

Question22: Which statement regarding compression for temporary tables is true?

Question23: Which type of table space can be associated with only one storage group?

Question24: The following commands are executed against a database named MY_DB, which has been configured to use archival logging:

Which statement is true?

Question25: If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?

Question26: Which statement about insert time clustering tables (ITC) is true?

Question27: Which statement about the ADMIN_MOVE_TABLE procedure is true?

Question28: Which statement is correct for a user who holds SECADM authority?

Question29: Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

Question30: If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?

Question31: What authorization is needed to use the AUDIT statement to create an audit policy?

Question32: You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?

Question33: What authority must be held to create a trusted context?

Question34: A table named SALES was created as follows:

If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?

Question35: Which statement about referential constraints is true?

Question36: Which statement regarding SECADM authority is true?

Question37: Which statement about range-clustered tables is true?

Question38: Which statement about Binary XML is FALSE?

Question39: What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

Question40: Which statement is NOT true about a database restore operation?

Question41: Which action can a DBA take to retrieve bufferpool metrics information?

Question42: Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

Question43: What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

Question44: Which SQL data type CANNOT be used to store XML indexed values?

Question45: Which statement describes a way to minimize the impact of a RUNSTATS operation?

Question46: Which statement about adaptive compression is true?

Question47: What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

Question48: Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?

Question49: Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?

Question50: Which command will enable automatic reorg on a database?

Question51: Which authority is required to revoke SECADM authority?

Question52: The following statement is run:

Which statement about the ACCT_BALANCE column is true?

Question53: Which statement about updating index statistics with the RUNSTATS command is true?

Question54: Which authorities can be audited with the AUDIT statement?

Question55: A user with SYSADM authority executes the following commands at host SERVER1:

Assuming the user ADMINISTRATOR exists, what could be causing the problem?

Question56: By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

Question57: What does the FLUSH PACKAGE CACHE statement do?

Question58: How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?

Question59: Which statement about BEFORE triggers is FALSE?

Question60: If an MQT named Q1_SALES was created as follows:

Which statement will execute successfully?

Question61: In IBM Data Studio, where can you schedule script-based jobs?

Question62: Which statement regarding SECADM authority is true?

Question63: Table TAB_A resides within table space TBSP_1.

Which statement is correct?

Question64: Given a system-period temporal table POLICY_INFO with its associated history table HIST_POLICY_INFO, which statement is true?

Question65: If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

Question66: What is an informational constraint?

Question67: Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?

Question68: Which command is used to export connectivity configuration information from a file known as a configuration profile?

Question69: Which statement is correct when describing Range Clustered Tables (RCT) as compared to regular base tables that use at least one index?

Question70: What is the purpose of the Design Advisor?

Question71: The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:

What commands must be run to enable real-time statistics collection on the SAMPLE database?

Question72: A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?

Question73: When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?

Question74: Which command can be used to restore a corrupted database using only the recovery history file?

Question75: Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?

Question76: What information can be obtained by analyzing EXPLAIN data?

Question77: Which is the suggested way to restore a database with a subset of its original table spaces?

Question78: Table TAB1 was created as follows:

Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compression?

Question79: What can be used to provide input to the Design Advisor?

Question80: When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

Question81: If the following statements are executed in the order shown:

Which statement is true?

Question82: What type of Label-Based Access Control (LBAC) security label component is used to define a scale in which the first element listed represents the highest level of trust a person can have and the last element listed represents the lowest level of trust a person can have?

Question83: How can you remove all effects of compression from an index?

Question84: Which user-managed file system is required for DB2 pureScale deployments?

Question85: What are two purposes of the SET INTEGRITY statement? (Choose two.)

Question86: Which statement about the db2pd tool is true?

Question87: Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

Question88: How is the time that an agent waits for log records to be flushed to disk calculated?

Question89: Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

Question90: Which statement about DB2 aggregate registry variables is true?

Question91: Where are column mask definitions stored?

Question92: You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?

Question93: Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

Question94: Which statement about triggers is FALSE?

Question95: What authorization is needed to execute the CREATE MASK statement?

Question96: A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

Question97: What authority is required to create, alter and drop workload management objects?

Question98: A partitioned table named SALES was created as follows:

Which statement about the PARTS_IDX index is true?

Question99: What is the FLUSH PACKAGE CACHE statement used for?

Question100: Which of the following table types is NOT supported by the load utility?

Question101: Which statement about primary keys is true?

Question102: Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

Question103: Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?

Question104: What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

Question105: Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server?

Question106: What authority is required to grant a user ACCESSCTRL authority?

Question107: What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

Question108: Table TAB_A resides within table space TBSP_1.

Which statement is correct?

Question109: You are tasked with using the Export, Import, and Load utilities to move data from a UNIX platform database to a Windows platform database. What file format is recommended for moving data across platforms?

Question110: Which command is used to import connectivity configuration information from a file known as a configuration profile?